Blogs
Discover a boundless realm of knowledge and personal growth, all conclaiently accessible right at your fingertips.
Year on Year (YoY) comparisons in Power BI
Time trends are among the most common ways to provide insights in almost every industry. Applicable in every dataset from Sales, Impressions, Website visits, etc, they are great at generating insights around: Average baseline, Linear or Exponential, Seasonality, Growth
Jackie Tejwani
Oct 7, 2024
Data Modelling in Power BI
Data modelling is the make-or-break stage for any Power BI Report. A well-built data model ensures your report refreshes fast and scales with compounding data.
Jackie Tejwani
Sep 15, 2024
Ethics in Data Science: What Every Business Leader Should Know
Learn the key ethical issues in data science and how business leaders can navigate them responsibly.
Saartje Ly
Sep 6, 2024
How to Clean Your Business Data for Better Insights
Learn how to clean and maintain your business data for accurate analysis and better decision-making.
Saartje Ly
Sep 3, 2024
KPIs and Metrics That Matter: Measuring Success with Data
Learn how to measure business success by tracking key KPIs and metrics that truly matter.
Saartje Ly
Sep 2, 2024
How Data Segmentation Can Drive Targeted Marketing
Learn how data segmentation can help you understand your customers and create targeted marketing campaigns.
Saartje Ly
Sep 2, 2024
5 Common Data Science Myths Busted for Business Leaders
Debunk five common myths about data science and discover how it can benefit your business.
Saartje Ly
Sep 2, 2024
A/B Testing in Power BI
A/B testing is a popular statistical technique used to understand whether a change to method actually performs better. It is commonly used in website design, marketing campaigns, and health care.
Jackie Tejwani
Aug 26, 2024
Azure Interview Questions
Get fully prepared for your next Azure interview with these essential questions covering key services, architecture, and best practices.
Saartje Ly
Aug 21, 2024
Creating an Azure Storage Account
Learn how to create and configure an Azure Storage account, covering redundancy options, advanced settings, networking, and encryption.
Saartje Ly
Aug 21, 2024
Introduction to Cloud
Discover the benefits and key characteristics of cloud computing, including its service models, deployment options, and global reach.
Saartje Ly
Aug 20, 2024
Making Data-Driven Decisions: A Guide for Business Leaders
Learn how business leaders can make smarter, data-driven decisions to drive growth and innovation.
Saartje Ly
Aug 19, 2024
Data Science for Small Businesses: Simple Steps to Get Started
Unlock the power of data science for your small business with simple, actionable steps.
Saartje Ly
Aug 19, 2024
8 Python Libraries You Must Know for Data Science
Learn about key Python libraries crucial for data analysis, visualization, machine learning, and web scraping.
Saartje Ly
Aug 14, 2024
Advanced SQL
Master advanced SQL techniques like EXISTS, CASE, and RECURSIVE with practical examples using Customers and Orders tables.
Saartje Ly
Aug 13, 2024
Intermediate SQL
Master intermediate SQL with techniques on filtering, joins, subqueries, aggregations, and more. Enhance your data querying skills!
Saartje Ly
Aug 7, 2024
An Introduction to SQL
Discover SQL basics: manage, query, and manipulate relational databases efficiently. Learn essential commands and operations for effective data handling.
Saartje Ly
Aug 6, 2024
A Comprehensive Guide to Understanding DAX in Power BI
Explore DAX in Power BI with this guide on key functions, contexts, and practical applications for data analysis.
Saartje Ly
Jul 29, 2024
From Concatenation to Data Blending and Optimization in Tableau
Learn how to concatenate fields, format sales data, blend multiple data sources, and optimize visualizations in Tableau.
Saartje Ly
Jul 29, 2024
Pivot data using Power Query in Power BI
Learn how to transform and pivot data in Power BI for simplified analysis and improved data structure.
Saartje Ly
Jul 29, 2024
How to use Power BI DAX
This blog guides you through solving common Power BI questions with DAX, covering calculations, totals, and logical functions.
Saartje Ly
Jul 23, 2024
Learn DAX fundamentals in Power BI
Learn to solve common questions using DAX in Power BI, from calculating total revenue to categorizing columns.
Saartje Ly
Jul 23, 2024
How to create a word cloud in Tableau
Learn how to effectively use text fields for size, color, and text to create a word cloud in Tableau.
Saartje Ly
Jul 17, 2024
How to use Joins in Tableau
Learn how to perform joins in Tableau to combine data from multiple sources, enhancing your visualizations with richer information.
Saartje Ly
Jul 17, 2024
Tableau Dashboard tips
Learn to create and format interactive Tableau dashboards, adding features for effective data visualization and enhanced user experience.
Saartje Ly
Jul 17, 2024
Create a vertical bar chart in Tableau
Get started with Tableau by importing Titanic data from Kaggle, visualizing age distributions, and adding labels for better insights.
Saartje Ly
Jul 17, 2024
10 Tableau tricks you should know
Discover 10 essential Tableau tips and shortcuts to streamline your workflow and enhance your data visualization process.
Saartje Ly
Jul 16, 2024
What is data science and why it matters for a business
Discover how data scientists analyze and transform data to extract knowledge, drive decisions, and gain competitive advantages.
Saartje Ly
Jul 9, 2024
Making data work for you in Tableau
Learn how to clean and merge messy datasets in Tableau by interpreting Excel files, handling incomplete values, and using grouping and aliases for effective visualization.
Saartje Ly
Jul 9, 2024
Tableau: adding value to analysis - trends, distributions, and forecasting
Learn how to create trend lines, distribution bands, and five-year sales forecasts using Tableau's Sample Superstore Workbook.
Saartje Ly
Jul 9, 2024
Telling a data story with dashboards in Tableau
Create engaging Tableau dashboards, blending data and customizing filters, to transform raw data into compelling visual stories.
Saartje Ly
Jul 1, 2024
Tableau: Formatting a visualization
Learn to format Tableau visualizations by customizing fonts, colors, filters, and themes using the Sample Superstore workbook for enhanced appearance and functionality.
Saartje Ly
Jul 1, 2024
Tableau: Table Calculations
Explore quick table calculations in Tableau: direction, differences, pane calculations, dimensions, and secondary calculations using Sample Superstore.
Saartje Ly
Jul 1, 2024
Tableau: Using row-level and aggregate calculations
Learn about Tableau's three levels of calculations, parameters, dynamic axes, KPIs, and ad hoc calculations using the Sample Superstore workbook.
Saartje Ly
Jun 27, 2024
Tableau: From foundational to advanced visualizations
Learn about dimensions, measures, and how discrete vs continuous fields impact visualizations using Tableau's Sample Superstore Workbook.
Saartje Ly
Jun 27, 2024
Working with data in tableau
Master Tableau techniques for working with extracted and live data, filtering, joins, and blends to enhance performance and real-time insights for strategic planning.
Saartje Ly
Jun 2, 2024
Tableau Fundamentals
Discover how to use Tableau for creating interactive dashboards, connecting to data sources, and visualizing data through user-friendly steps and features.
Saartje Ly
Jun 1, 2024
Microsoft Azure Overview: Creating Service Principals
Learn Azure RBAC to manage access, define permissions, and create role assignments for fine-grained Azure resource management.
Saartje Ly
May 26, 2024
Azure SQL Databases: Introduction
Discover Azure SQL, a family of SQL cloud databases that offer flexible options for application migration, modernization, and development, providing a consistent and unified experience.
Saartje Ly
May 25, 2024
Microsoft Azure Overview: Authentication, Authorization, Applications & Security Principals.
Explore managing Azure resources using Azure Active Directory for secure authentication and controlled application access.
Saartje Ly
May 25, 2024
How to read data from an API in Power BI
Learn how to load API data into Power BI by using the Web data source to connect to public or private APIs for real-time data integration.
Saartje Ly
May 25, 2024
Creating a Resource in Microsoft Azure
Follow these steps to create a SQL database in Azure, configuring project details, networking, security, and additional settings for a customized setup.
Saartje Ly
May 19, 2024
A Microsoft Azure Introduction and how to create an Azure Account
Learn the basics of Azure, Microsoft's cloud computing platform, and explore the benefits of cloud computing and how to create and manage resources efficiently.
Saartje Ly
May 19, 2024
Working with M (Power Query) in Power BI
Discover how to use M language in Power Query to transform and combine data creatively in Power BI.
Saartje Ly
May 18, 2024
Notifications in your Power BI report
Implement a notification bell in Power BI to keep users updated with key messages and information directly within the report.
Saartje Ly
May 12, 2024
5 design tricks for Power BI dashboards
Enhance your Power BI dashboard's visual appeal with alignment, white space, rounded corners, shadows, and custom backgrounds from PowerPoint.
Saartje Ly
May 11, 2024
How to sort by month in Power BI
Learn how to sort months correctly in Power BI by creating a Month Number column and using it to sort your visualizations accurately.
Saartje Ly
May 5, 2024
4 useful Power BI visualizations that Excel doesn't offer
Learn how to enhance your Power BI reports with advanced visuals like ribbon charts, decomposition trees, scatter charts, and infographics.
Saartje ly
May 5, 2024
Power BI Slicers
Learn how to effectively use various slicers in Power BI to enhance your data filtering, visualization capabilities, and overall data analysis.
Saartje Ly
May 4, 2024
10 Power BI tips for better dashboards
Explore these 10 Power BI tips to enhance your reports with advanced features like conditional formatting, custom images, tooltips, and more.
Saartje Ly
Apr 28, 2024
Perform Advanced Analytics in Power BI
Unlock advanced analytics in Power BI with techniques like grouping, binning, drill down/up, and AI visuals for deeper insights.
Saartje Ly
Apr 27, 2024
Create a basic Power BI dashboard
Learn how to create text banners and add visualizations to your Power BI report for a polished, professional look.
Saartje Ly
Apr 21, 2024
Accessibility in Power BI
Explore Power BI's accessibility features, including built-in options like keyboard navigation and high contrast view, and configurable options such as alt text and tab order.
Saartje Ly
Apr 21, 2024
Report features in Power BI
Learn how to create and format visualizations in Power BI, including adding slicers, drill-through pages, and conditional formatting for dynamic, interactive reports.
Saartje Ly
Apr 21, 2024
Optimizing model performance in Power BI
Learn the steps and best practices to optimize a data model for enterprise-level performance using DirectQuery, variables in DAX, and other optimization techniques.
Saartje Ly
Apr 16, 2024
Model calculations using DAX in Power BI
DAX in Power BI uses functions and operators to create calculated tables, columns, and measures for dynamic data analysis.
Saartje Ly
Apr 16, 2024
Design a Data model in Power BI
Learn data modeling to design efficient databases, ensure data integrity, and optimize performance for storage, retrieval, and analysis.
Saartje Ly
Apr 12, 2024
Merging tables in Power BI
Learn how to merge tables in Power BI using various joins to combine data based on specified relationships or matching criteria.
Saartje Ly
Apr 12, 2024
Cleaning data in Power BI with Power Query Editor
Learn how to clean and transform data in Power BI using the Power Query Editor with essential tasks like promoting headers and replacing values.
Saartje Ly
Apr 8, 2024
Pandas library for Data Science
Explore the pandas library for Python, a powerful tool for data manipulation and analysis with high-level data structures and functions.
Saartje Ly
Apr 3, 2024
Creating a basic Azure Function App and Azure Function
Learn how to create a basic Function App in Microsoft Azure Portal and build a Python function using VS Code.
Saartje Ly
Apr 3, 2024
An introduction to Power BI
Discover how Power BI transforms data into interactive reports and dashboards, providing insightful business intelligence and enhancing data-driven decision-making.
Saartje Ly
Apr 3, 2024
An introduction to Azure Functions
Learn about Azure Functions, Microsoft's serverless computing service for building scalable, event-driven applications effortlessly.
Saartje Ly
Apr 2, 2024