Data Analyst & Visualization with Power BI Course Data Visualization

Data Analyst & Visualization with Power BI Course

The Data Analyst & Visualization with Power BI course is a comprehensive program designed to equip individuals with the skills to analyze and visualize data using Microsoft Power BI. Participants learn how to import and transform data from various sources, create data models, and develop interactive visualizations and reports. The course covers topics such as data cleaning, data shaping, creating relationships between datasets, and implementing calculations and measures. Participants also gain expertise in creating visually appealing and interactive dashboards, utilizing Power BI's extensive range of visualizations and features. Through hands-on projects and exercises, students apply their knowledge to real-world scenarios, gaining practical experience in data analysis and visualization using Power BI.

Course Module

Getting started

• Introducing Power BI
• A quick look at Power BI Desktop
• A quick look at the Power BI service



Power BI and Excel

• Introduction - using Excel data in Power BI
• Upload Excel data to Power BI
• OneDrive for Business with Excel
• Import Power View and Power Pivot to Power BI



Shaping and Transforming Data

• Introduction to the Query Editor
• Clean and transform your data with the Query Editor
• Cleaning irregularly formatted data



Modeling

• Introduction to modeling your data
• How to manage your data relationships
• Optimizing data models
• Introduction to DAX
• DAX calculation types
• DAX functions
• Create calculated columns
• Create calculated measures
• Create calculated tables Explore your time-based data



Visualizations

• Introduction to visuals in Power BI
• Create and customize simple visualizations
• Modify colors in charts and visuals
• Shapes, text boxes, and images
• Page layout and formatting
• Interactions among visualizations
• Visual hierarchies and drill-down
• Using custom visualizations
• R integration in Power BI Desktop



Publishing and sharing

• Introduction to the Power BI service
• Publish Power BI Desktop reports
• Create and configure a dashboard
• Share dashboards with your organization
• Quick insights in Power BI
• Introduction to security, and workspaces
• Create workspaces in Power BI
• Manually republish and refresh your data
• Install and configure a personal gateway
• Print and export dashboards and reports
• Publish to web



Getting Data

• Available data sources in Power BI Desktop
• Connecting to data sources
• Connecting to a database
• Connecting to a CSV file