Master Data VisualizationExcel, Power Bi, Tableau Essential

What you'll learn
Have a solid understanding of Excel and Power BI fundamentals.
Be proficient in performing data analysis, visualization, and reporting tasks using Excel and Power BI.
Possess the skills to manipulate and clean datasets efficiently.
Be able to create interactive dashboards and reports for effective data presentation.
Have the confidence to leverage Excel and Power BI to tackle real-world data challenges.
Receive a certificate of completion, recognizing their achievement in mastering Excel and Power BI.
A comprehensive understanding of Tableau's core functionalities and features
Proficiency in creating a wide range of visualizations for diverse data sets.
The ability to design interactive and intuitive dashboards for effective data communication.
Enhanced storytelling skills to convey insights and influence decision-making.
Confidence in utilizing Tableau to tackle real-world data challenges with finesse.
A certificate of completion, acknowledging your mastery of Tableau Essentials.
Requirements
No prior experience with Microsoft Excel or Power BI is required, but basic computer literacy will be helpful.
No prior experience with Tableau is necessary, but a basic understanding of data analysis concepts is beneficial.
Description
Course DescriptionWelcome to an exhilarating journey into the world of data mastery with our combined Excel, Power BI, and Tableau course! This comprehensive program is designed to transform data into a canvas for creativity and insight, equipping you with the skills to harness the power of these three essential tools. Through interactive learning experiences, expert guidance, and real-world applications, you'll evolve from a novice to a proficient data maestro.Embark on this exciting adventure where Excel, Power BI, and Tableau become your trusted allies in the quest for data-driven decision-making. Whether you're a professional seeking to enhance your data analysis capabilities, a manager looking to make informed decisions, or an individual aiming to acquire in-demand skills for career advancement, this course is your gateway to mastering data visualization, analysis, and reporting.What You'll Learn:Introduction to Data AnalysisUnderstanding the importance of data-driven decision-makingExcel MasteryFunctions and formulasData entry and manipulationData validation and cleaning techniquesPivotTables and Pivot Charts for data analysisPower BI ProficiencyIntroduction to Power BI and its componentsData importing from various sourcesData modeling and transformationCreating relationships between datasetsBuilding interactive dashboards and reportsSharing and collaborating on Power BI projectsTableau FundamentalsInstallation and setupData importing and preparationBasic and advanced functions: string, date, aggregate, logicalMastering visualizations: creating diverse and dynamic visualsGeographic mapping and geo data visualization End-to-End Project ImplementationComprehensive project integrating ETL (Extract, Transform, Load) processesMastering Data Publication and CollaborationPublishing to Tableau Cloud and collaborating on Tableau projectsWho Should Enroll:Professionals seeking to enhance their data analysis and reporting skillsBusiness analysts, data analysts, and BI professionals looking to streamline workflows and improve efficiencyManagers and decision-makers aiming to make data-driven decisions using Excel, Power BI, and TableauStudents and individuals interested in acquiring in-demand skills for career advancementPrerequisites:No prior experience with Microsoft Excel, Power BI, or Tableau is required, but basic computer literacy and a fundamental understanding of data analysis concepts will be beneficial.What You'll Gain:A solid understanding of Excel, Power BI, and Tableau fundamentalsProficiency in performing data analysis, visualization, and reporting tasks using these toolsSkills to manipulate and clean datasets efficientlyAbility to create interactive dashboards and reports for effective data presentationEnhanced storytelling skills to convey insights and influence decision-makingConfidence to leverage Excel, Power BI, and Tableau to tackle real-world data challengesA certificate of completion recognizing your achievement in mastering these essential data tools
Overview
Section 1: Excel and Power BI: From Fundamental Principles to Brilliant
Lecture 1 Introduction to Course
Lecture 2 Outline
Lecture 3 Intro to Data Analysis
Lecture 4 A Use Case of Data Analysis
Lecture 5 Links for the Course's Materials and Codes
Section 2: Excel
Lecture 6 Links for the Course's Materials and Codes
Lecture 7 Introduction and Installation
Lecture 8 Anatomy of a Spreadsheet and UI Tour
Lecture 9 Math Functions (Numeric)
Lecture 10 Math Functions (Basic)
Lecture 11 Math Functions (Aggregate)
Lecture 12 Math Functions (Rounding)
Lecture 13 Text Functions
Lecture 14 Information Functions
Lecture 15 Date and Time Functions
Lecture 16 Logical Functions
Lecture 17 Lookup Functions
Lecture 18 Formatting
Lecture 19 Pivot Table
Lecture 20 Print Formatting
Lecture 21 Project Part 1
Lecture 22 Project Part 2
Section 3: Power BI
Lecture 23 Links for the Course's Materials and Codes
Lecture 24 Intro to Power BI
Lecture 25 Installation
Lecture 26 UI Tour
Lecture 27 Importing Data
Lecture 28 Intro to Data Visualization
Lecture 29 Visualizations - Clustured Chart
Lecture 30 Visualizations - Formatting Charts
Lecture 31 Visualizations - Pie Chart and Donut Chart
Lecture 32 Visualizations - Funnel Chart
Lecture 33 Visualizations - Ribbon Chart and Card
Lecture 34 Visualizations - Include Exclude
Lecture 35 Visualizations - Themes
Lecture 36 Intro to Map Based Visualizations
Lecture 37 Map Based Visualizations - Map
Lecture 38 Map Based Visualizations - Filled Map
Lecture 39 Map Based Visualizations - Formatting Maps
Lecture 40 Intro to Data Modeling
Lecture 41 Creating Relationships
Lecture 42 What is DAX?
Lecture 43 DAX - Hands on
Lecture 44 DAX - Complex Functions
Lecture 45 DAX - Quick Measure
Lecture 46 DAX - New Column
Lecture 47 DAX - IF Function
Lecture 48 Intro to ETL Pipeline
Lecture 49 Extract Data from Multiple Files
Lecture 50 Extract Data from Multiple Sources
Lecture 51 Extract Data from Multiple Sources with Different Columns
Lecture 52 Transform Data
Lecture 53 Home Tabs for Transformation
Lecture 54 Project Part 1
Lecture 55 Project Part 2
Section 4: Tableau Essentials: From Foundations to Visualization Master
Lecture 56 Introduction to Instructor and Tableau
Lecture 57 Importance of Tableau
Lecture 58 What is tableau
Lecture 59 UseCase
Lecture 60 Links for the Course's Materials and Codes
Section 5: Tableau Fundamentals
Lecture 61 Links for the Course's Materials and Codes
Lecture 62 Installation and Setup
Lecture 63 UI Tour
Lecture 64 Import Data from Various Data Sources (Excel, CSV, etc.)
Lecture 65 Explore Data Pane and Data Source Pane
Section 6: Tableau Functions
Lecture 66 Links for the Course's Materials and Codes
Lecture 67 Functions (Presentation Canva)
Lecture 68 Functions (Presentation Canva)
Lecture 69 Basic Functions (ABS, Ceiling, Floor, Max, Min, Div, ZN)
Lecture 70 String Functions (Contains, endswith, find, findnth, len, lower, upper, split, trim)
Lecture 71 Date Functions (Dateadd, DateDiff, Datename, Day, Month, Year, isdate, Makedate, Maketime, Makedatetime, Now)
Lecture 72 Aggregate Functions (avg, max, median, min, sum)
Lecture 73 Logical Functions (if, and, else, or)
Section 7: Mastering Visualizations
Lecture 74 Links for the Course's Materials and Codes
Lecture 75 Visualizations – Bar Chart
Lecture 76 Visualizations – Line Chart
Lecture 77 Visualizations – Bullet Chart
Lecture 78 Visualizations – Text Table
Lecture 79 Visualizations – Gantt Chart
Lecture 80 Visualizations – Pie Chart
Lecture 81 Visualizations – Scatter Plot
Lecture 82 Visualizations – Area Chart
Lecture 83 Visualizations – Dual Axis Chart
Lecture 84 Visualizations – Bubble Chart
Section 8: Exploring Geographic Mapping
Lecture 85 Links for the Course's Materials and Codes
Lecture 86 Introduction to Geo Data Visualization
Lecture 87 Geographic Mapping
Lecture 88 Customizing Map Layers and Styles
Lecture 89 Creating a Dashboard
Section 9: End-to-End Project Implementation
Lecture 90 Links for the Course's Materials and Codes
Lecture 91 Starting the Projects
Lecture 92 PROJECT Part 1
Lecture 93 PROJECT Part 2
Lecture 94 PROJECT Part 3
Lecture 95 PROJECT Part 4
Lecture 96 PROJECT Part 5
Section 10: Mastering Data Publication and Collaboration with Tableau Cloud
Lecture 97 Links for the Course's Materials and Codes
Lecture 98 Publishing to Tableau Cloud
Professionals seeking to enhance their data analysis and reporting skills.,Business analysts and data analysts looking to streamline their workflows and improve efficiency.,Managers and decision-makers aiming to make data-driven decisions using Excel and Power BI.,Data analysts, business analysts, and BI professionals seeking to enhance their visualization skills.,Managers and decision-makers looking to leverage data visualization for strategic insights.,Professionals transitioning into roles that require data interpretation and storytelling,Students and individuals interested in mastering Tableau for career advancement


Homepage

https://www.udemy.com/course/master-data-visualizationexcel-power-bi-tableau-essential/