How to Connect Excel to SQL Server
Connecting Excel to SQL Server is important because it allows you to have access to up-to-date information. You can connect many spreadsheets to a single trusted data source in SQL Server. Then you can use Excel to refresh the data to be kept in sync. Excel has powerful but simple features that can help you […]
Power BI Tooltips
Advanced Power BI Tooltips Power BI by default gives you basic tooltips, which present you with the values included in your visual These are limited initially to the fields and values that have been used in creating that visual Add other fields into the tooltips You can easily add other fields by dragging […]
What is a Data Warehouse
What is a data warehouse? In simple terms, its a special type of database that is set up to help you answer your main business questions It adds value by focusing on reporting and analysis and taking reporting workload away from transactional systems All the data you need in one place A data […]
Management Information Health Check
Introducing our Management Information Health Check As a company director, it’s important to ensure that your management information is up-to-date and reliable. Having access to accurate data at the right time can help make informed decisions for your business. Unfortunately, not all businesses have access to simplified, organized and trusted data which can hold them […]
Drag and Drop Field Names in SQL (SSMS)
Drag and drop is a common and convenient way to move data and objects in SQL Server Management Studio (SSMS). With the object explorer, you can easily drag field names from a table. Then drop them into a query window to quickly create a SELECT statement. How to drag and drop field names in SQL […]
Conditional Format a line chart in Power BI
How to Conditional format a line chart in Power BI (This is a workaround to show you how you can conditional format a line chart in Power BI) Power BI does not at first seem to have an option to add conditional formatting to a line chart, but, there is a way to make it […]
How good is your Management Information
How good is your Management Information? Does it really give you what you need? or is it more of a frustration? Do you find yourself struggling to trust the reports, with differences from one report to the next? Does your reporting keep up with your business? or every time you add a new channel to […]
Tables in Excel
What are the top 10 reasons to use tables in Excel? Tables in excel are a great way to begin to add data structure, improving consistency and reliability of the data What are Tables in Excel? The Excel table is a powerful feature that lets you sort, organize, and analyse a set of data. It […]
SQL Timesaver – Add comma separators
This one-minute SQL timesaver showcases a free online comma separator tool, designed to simplify the process of adding comma separators to your SQL code. Delim.co is a Free Comma Separating Tool that separates one or more characters and text strings using delimiters such as commas (,), semicolon (;), quotes (\”, ‘), braces ({}), pipes (|), […]
Add a date dimension table in Power BI
How to easily add a date dimension table in Power BI in 1 minute What is a date dimension table A date dimension or calendar dimension is one of the most common tables in a reporting data model. It contains one row per date. It also has all different date attributes and classifications that you […]
