More on Topics to Cover in Data Analysis
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
- Create and Manage Data Hierarchies
- Filter and Slice Reports
- Create Dashboards
Use advanced analysis techniques
- Create Calculated Tables, Variables, and Parameters
- Enhance Visuals with Statistical Analysis
Enhance reports and dashboards.
Publish and share reports and dashboards.
Create and Manage workspaces.
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:
Adding Records to a table
Update select where operators
And, or, in, with, as, like,
Order by and group by
Joins and unions
Import and export tables
 BULB, 'Write to Earn. Read to Earn' (online, 2022) <https://www.bulbapp.io/>