More on Topics to Cover in Data Analysis

892o...qf72
30 Sept 2022
19




POWER BI

Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. It enables users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

Topics to cover:
Connect to data sources.
Perform data cleaning, profiling, and shaping with the query editor.
Visualize data with Power BI
Enhance data analysis by adding and customizing visual elements.
Model data with calculations with DAX- Data Analysis Expression

Create interactive visualizations

  1. Create and Manage Data Hierarchies
  2. Filter and Slice Reports
  3. Create Dashboards

Use advanced analysis techniques

  1. Create Calculated Tables, Variables, and Parameters
  2. Enhance Visuals with Statistical Analysis


Enhance reports and dashboards.
Publish and share reports and dashboards.
Create and Manage workspaces.


SQL


SQL means Structured-Query-Language, through which you can communicate with databases. It helps you to extract, manipulate, and manage data stored in the Relational database Management System (RDMS). 
In this course, you’ll first learn to extract data, join tables together, and perform aggregations. Then dive into more complex analysis and manipulations using subqueries, temp tables, and window functions. Covering these topics will enable you to write efficient SQL queries to handle a variety of data analysis tasks successfully.

Topics to Cover:
Basic concepts
Creating Database
Entity-relationship modeling
Adding Records to a table
Update select where operators
And, or, in, with, as, like,
Aggregations
Order by and group by
Joins and unions
Case Statement
Import and export tables
Relational model
SQL Subqueries
Data Manipulation
SQL Injections







References 

[1] BULB, 'Write to Earn. Read to Earn' (online, 2022) <https://www.bulbapp.io/>

2 Comments

No comments yet.