Archive for October 2024
Scripting views for SQL databases
Scripting views for SQL databases Learn how to take your SQL queries and script them into Views. These objects can then be used by other software like PowerBI, and Excel to build valuable reports and visualizations. Learn how to script views The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt…
Read MoreDesigning relationships for databases
Designing relationships for databases Learn how to design relationships for a basic database. If you can understand how to create relational designs, then you will understand how to read great designs and deal with bad designs. Learn How To Design Relations for Databases The Data Skills Survival Kit Series If you’re a data analyst, you’ve…
Read MoreCreating a SharePoint back end from a database
Creating a SharePoint back end from a database Learn how to export a relational database from Access to SharePoint, enabling real-time data access with tools like Excel and Power BI. By leveraging SharePoint’s features, you can manage and interact with data on the go while maintaining relational data structures. Learn How To Create a Sharepoint…
Read MoreCreating tables and joins to recode data
Creating tables and joins to recode data There are times where you can’t write a enough replace commands, or conditional statements to clean bad data. Learn how to create a control table to clean data in mass. Learn How To Recode Data The Data Skills Survival Kit Series If you’re a data analyst, you’ve no…
Read MoreMerging data and building basic calculations into a data set
Merging data and building basic calculations into a data set Learn how to merge data from different sources and build basic calculations into a dataset. See how to analyze data by creating a comprehensive dataset for further analysis. Learn How To Merge and Calculate Data The Data Skills Survival Kit Series If you’re a data…
Read MoreAdding data leveraging cross joins
Adding data leveraging cross joins We use joins in data to effectively report on data, but have you ever considered using them to create data? When faced with adding repetitive data for a project that applies across the board learn to leverage cross joins. Learn How To Leverage Cross Joins The Data Skills Survival Kit…
Read MoreUsing date functions to create follow up data
Using date functions to create follow up data When you have data; you can use it to create valuable data sets to help automate or notify for other processes. Learn how to use date functions to create valuable follow up and notifications data. Learn How To Use Date Functions The Data Skills Survival Kit Series…
Read MoreBuild letter size for reports using Power BI Desktop
Build letter size for reports using Power BI Desktop You need all the features of PowerBI desktop, but at the end of the refresh process this information needs to be packaged and sent via PDF. Discover how to adjust your layouts to get the best of PowerBI and meet the delivery requirements Learn How To…
Read MoreBuild paginated reports
Build paginated reports Learn how to quickly build basic paginated reports using PowerBI Report Builder. Learn How To Build Paginated Reports The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why…
Read MoreBuilding a brief for a data project
Building a brief for a data project We spend so much time on techniques to visualize data but little on how to get the information into the hands of others. It’s not always about the final product. You may find there are lots of project details and creating an effective brief will be a life…
Read More