Location

Community Services & Continuing Education - Cairo

Objectives

• Ability to create interactive reports and dashboards, create beautiful visualizations, generate real-time reports, analyze different types of data, and generate reports from a variety of data sources

Outcomes

Enhance reporting skills Enhance data analysis skills Analyze data from different data sourcesCreate Beautiful and Interactive Dashboards

Course Contents

WHAT IS POWER BI ?INSTALIING POWER BI DESKTOP CONNECTING POWER BI TO SOURCES WORKING WITH QUERY EDITOR UNDERSTADING DATAMODEL AND VISULAZTION Using the Attached Project FilesUnderstanding the Power BI Desktop WorkflowExploring the Interface of the Data ModelUnderstanding the Query Editor InterfaceImportant! Creating the Project File & Recommended SettingsConnecting Power BI Desktop to Source FilesKeeping & Removing RowsWorking with FiltersRemoving Empty RowsSaving the Project DraftAppending QueriesWorking with ColumnsReplacing ValuesFormatting Data & Handling Formatting ErrorsPivoting & Unpivoting DataSplitting ColumnsCreating Groups & Cleaning Up our ProjectWhat we Achieved & How to ContinueTheory Time: The Star SchemaHow we Use the Star Schema in our ProjectQuery Duplicates vs ReferencesCreating the DIM-Region Table & Removing DuplicatesCreating Tables ManuallyTheory Time: Merging QueriesUnderstanding "Join Kind"Merging Queries AppliedFinishing the DIM