Login

**BaDshaH** · 07-20-2023, 05:50 PM

Published 7/2023
Created by Simon Sez IT
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 428 Lectures ( 53h 53m ) | Size: 26.6 GB

Tell a story with your data using Excel PivotTable, Power BI, Alteryx, Tableau, and Qlik Sense in this 10-course bundle!

[b]What you'll learn[/b]
How to create PivotTables
Using the fields pane and adding fields and calculated fields
Formatting numbers in PivotTable
Different ways to summarize data
Creating PivotCharts and adding sparklines and slicers
Combining data from multiple worksheets for a PivotTable
How to create stunning, interactive dashboards with Power BI
How to share your analysis and dashboards using Power BI Online
Importing Excel, Text, and CSV files into Power BI Desktop and combining files
Data Modelling, relationship types, and troubleshooting relationship issues
Creating a Shared Workspace in Power BI Service
Creating reports and dashboards, pinning visualizations to the dashboard, and setting up scheduled refreshes
How to import and transform data in Power Query
Advanced Tableau charts-circular, sunburst, bump, funnel, candlestick, and Sankey charts
Connect and manage data sources in Tableau
Create a dashboard in Tableau and animate your visualizations
Use calculated fields and spatial functions in Tableau
Level of Detail (LOD) expressions
Advanced filters and table calculations in Tableau
Using Alteryx workflows to cut out repetitive tasks
Data cleansing, manipulation, binning, and grouping in Alteryx
Take your apps and macros to the next level in Alteryx
Using multiple files and Calgary in Alteryx
All about Machine Learning and the Alteryx Intelligence Suite
How to become a Qlik Sense designer
All about the different charts and graphs available in Qlik Sense
How to use the Qlik Sense Geo Analytics tools (maps)

[b]Requirements[/b]
Access to the relevant software/application is beneficial (Excel, Power BI, Tableau Desktop, Alteryx, and Qlik Sense)
Basic to intermediate knowledge of Microsoft Excel is needed
An understanding of data analytics is beneficial

[b]Description[/b]
** This course bundle includes practice exercises and downloadable data files to work and follow along with, plus LIFETIME access!In this incredible-value, ten-course bundle, learn and master the essential tools to help turn your large complex data into meaningful visualizations that are easier to understand.If you want to start with data analytics and visualization, then this Data Storytelling course bundle is a good place to begin. This bundle includes ten full beginner and advanced courses in Excel PivotTable, Microsoft Power BI, Alteryx, Tableau, and Qlik Sense that will equip you with the best tools to master data visualization techniques.What's included?PivotTables for BeginnersHow to clean and prepare your dataCreating a basic PivotTableUsing the PivotTable fields paneAdding fields and pivoting the fieldsFormatting numbers in PivotTableDifferent ways to summarize dataGrouping PivotTable dataUsing multiple fields and dimensionThe methods of aggregationHow to choose and lock the report layoutApplying PivotTable stylesSorting data and using filtersCreate pivot charts based on PivotTable dataSelecting the right chart for your dataApply conditional formattingAdd slicers and timelines to your dashboardsAdding new data to the original source datasetUpdating PivotTables and chartsAdvanced PivotTablesHow to do a PivotTable (a quick refresher)How to combine data from multiple worksheets for a PivotTableGrouping, ungrouping, and dealing with errorsHow to format a PivotTable, including adjusting stylesHow to use the Value Field SettingsAdvanced Sorting and Filtering in PivotTablesHow to use Slicers, Timelines on multiple tablesHow to create a Calculated FieldAll about GETPIVOTDATAHow to create a Pivot Chart and add sparklines and slicersHow to use 3D Maps from a PivotTableHow to update your data in a PivotTable and Pivot ChartAll about Conditional Formatting in a PivotTableHow to create amazing-looking dashboardsPower BI for Beginner:What is Power BI and why you should be using it.To import CSV and Excel files into Power BI Desktop.How to use Merge Queries to fetch data from other queries.How to create relationships between the different tables of the data model.All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.All about using the card visual to create summary information.How to use other visuals such as clustered column charts, maps, and trend graphs.How to use Slicers to filter your reports.How to use themes to format your reports quickly and consistently.How to edit the interactions between your visualizations and filter at visualization, page, and report level.Power BI Intermediate:Importing and transforming data in Power QueryImporting Excel, text, and CSV files and combining filesEnabling/disabling load and report refreshResolving data import errorsData modeling, relationship types, and troubleshooting relationship issuesMeasures vs. calculated columnsCreating a date table with DAXCreating additional and conditional columnsUsing the ROUNDUP and SUMX functionsCreating quick measures and key measures tablesThe DAX - CALCULATE functionTables vs. matrix tablesFormatting visualizations and applying conditional formattingUsing column, line, and map chartsGauge and card visualizationsUsing slicers and filters and applying design elementsCreating a shared workspace in Power BI serviceBuilding reports and dashboardsPinning visualizations to the dashboardSetting up scheduled refreshesAlteryx for Beginners:Using Alteryx workflows to cut out repetitive tasksBuilding visual workflows in AlteryxHow to make the most of 'Favorite Tools' as core Alteryx building blocksFiltering data in AlteryxUsing the basic functions in Alteryx to match dataHow to dynamically rename datasetsHow to parse data in AlteryxCreating reports in Alteryx that run on demandUsing the predictive tools in Alteryx to perform data analysisBuilding a k-centroid clustering model using AlteryxCreating a logistic regression in AlteryxMaking a decision tree-based regression in AlteryxConstructing a random forest-based modelAlteryx Advanced:Using multiple files and CalgarySampling data and using wild matchesData cleansing, manipulation, binning, and groupingUsing RegEx (regular expressions) and parsing XMLWorking with In-DatabaseBlending, selecting, and summarizing dataTake your apps and macros to the next levelUsing iterative and batch macrosUnderstanding app errors and conditionsCustomizing apps and macrosAll about Machine Learning and the Alteryx Intelligence SuiteTableau for Beginners:What Tableau is and the product suiteWhat business intelligence isThe Tableau interface and its major functionsWhich data structures are suitable for TableauHow Tableau reads and categorizes dataDifferent data concepts and theoryHow to connect and manage data sources in TableauHow to navigate the Tableau workspaceHow to build a view and different chart types in TableauHow to create a dashboard in TableauHow to publish and share a workbookHow to use calculated fields in TableauHow to use numeric, string, conditional, and analytical expressions/functions in TableauTableau Advanced Tongue

arameters and sample use casesLevel of Detail (LOD) expressionsWorking with groups and setsUse of spatial functionsAdvanced filtersTable calculationsHow to add interactivity using actionsAnimating your visualizationsAdvanced Tableau charts-circular, sunburst, bump, funnel, candlestick, and Sankey chartsBuilding geospatial dashboards and sales dashboardsCreating dashboards that utilize radial chartsQlik Sense for Beginners:The difference between Qlik Sense and Qlik ViewHow to load data in Qlik SenseHow to create and upload apps in Qlik SenseAll about the different charts and graphs available in Qlik SenseAll about Tables and Pivot Tables in Qlik SenseHow to create your analysis in the Story Telling tabAbout numeric and string functions in Qlik SenseHow to use the date and time formatting functionsHow to use Conditional FunctionsHow to combine tables using JOIN, KEEP and CONCATENATEHow to use different charts and tablesHow to use the Qlik Sense Geo Analytics tools (maps)Qlik Sense AdvancedHow to use system and user-defined variables effectivelyHow to use a variable's input to create dynamic dimensions and measuresTo maximize the dynamic loading feature to import data from diverse sources in numerous waysTo write powerful and elegant scripts and subroutinesHow to make the most of Qlik Sense's conditional functions, including Match and Pick and to work with the values the functions return.How to use the Alternate States feature to create and compare visualizationsTo use Cascading Style Sheets (CSS) to design highly customized visualizations and dashboardsTo use geo-analytics and spatial functions to work with location-based dataHow to layer components with functions such as the Bubble, Line, Area, Heatmap, and Geodata Layers.To transform data with Qlik's toolbox of analytical functions to perform geometric, aggregating, route-based, and look-up operations.This course bundle includes:50+ hours of video tutorials390+ individual video lecturesCertificate of completionCourse and exercise files to help you follow along

Who this course is for
Data Analysts and Data Scientists
Anyone looking to turn raw data into meaningful business visualizations
People looking to perform Data Analysis using Excel
People who are brand-new to PivotTables, Power BI, Tableau, Alteryx, or Qlik Sense
Users who have a foundation in PivotTables, Power BI, Tableau, Alteryx, or Qlik Sense and are seeking to advance their skills
Business Intelligence Analysts

Homepage